﻿
CREATE PROCEDURE [dbo].[SYS_ServiceConfiguration_ADD]
(
	@Service  varchar(50),
	@Type  varchar(500),
	@Value  varchar(8000),
	@CreateBy int,
	@ConfigurationId int OUTPUT
)

AS

INSERT INTO SYS_ServiceConfiguration
(
	[Service],
	[Type],
	[Value],
	[Status],
	[rowGUID],
	[CreateBy],
	[UpdateBy],
	[CreateDate],
	[UpdateDate]
)
VALUES
(
	@Service,
	@Type,
	@Value,
	1,
	newid(),
	@CreateBy,
	@CreateBy,
	getdate(),
	getdate()
)

SET @ConfigurationId = SCOPE_IDENTITY();

--#endregion

